<?php

class MayzusAccountController extends Controller {

    /**
     * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
     * using two-column layout. See 'protected/views/layouts/column2.php'.
     */
    public $layout = '//layouts/column2';

    /**
     * @return array action filters
     */
    public function filters() {
        return array(
            'accessControl', // perform access control for CRUD operations
            'postOnly + delete', // we only allow deletion via POST request
        );
    }

    /**
     * Specifies the access control rules.
     * This method is used by the 'accessControl' filter.
     * @return array access control rules
     */
    public function accessRules() {
        return array(
            array('allow', // allow all users to perform 'index' and 'view' actions
                'actions' => array('index', 'getPostAccounts', 'view', 'updatePost', 'canPost', 'addAccount', 'updateAccount', 'deleteAccount', 'deleteAll', 'getAccounts', 'updateWorking', 'updateAllWorking'),
                'users' => array('*'),
            ),
            array('allow', // allow authenticated user to perform 'create' and 'update' actions
                'actions' => array('create', 'update'),
                'users' => array('@'),
            ),
            array('allow', // allow admin user to perform 'admin' and 'delete' actions
                'actions' => array('admin', 'delete'),
                'users' => array('admin'),
            ),
            array('deny', // deny all users
                'users' => array('*'),
            ),
        );
    }

    /**
     * 0 or null means initial save, 1 tried to signup and 2 for signup done, 3 signup done but manualy mail varification
     * 4 username and pass not valid, 5 means block user by mayzus.
     */
    public function actionAddAccount() {
        $response = "<Response>";
        if (!isset($_POST['request'])) {
            $response = $response . "<errorcode>000</errorcode><message>Request paramater is not found.</message></Response>";
            echo $response;
            return;
        }
        $request = $_POST['request'];

        $xml = simplexml_load_string($request);
        $username = $xml->username;
        $password = $xml->password;

        $errorMsg = $this->mayzusAuthenticate($username, $password);
        if ($errorMsg != "") {
            $response = $response . "<errorcode>000</errorcode><message>" . $errorMsg . "</message></Response>";
            echo $response;
            return;
        }

        $record = MayzusUser::model()->findByAttributes(array('username' => $username));

        $model = new MayzusAccount;
        $model->user_id = $record->id;
        $model->email = $xml->email;
        $model->email_pass = $xml->email_pass;
        $model->fw_email = $xml->fw_email;
        $model->fw_email_pass = $xml->fw_email_pass;
        $model->username = $xml->mayzus_username;
        $model->password = $xml->mayzus_password;
        $model->verify_code1 = $xml->verify_code1;
        $model->verify_code2 = $xml->verify_code2;
        $model->date_of_birth = $xml->date_of_birth;
        $model->referral = $xml->referral;
        $model->working = 0;
        $model->last_posted_date = date("Y-m-d H:i:s");
        if ($model->save()) {
            $response = $response . "<errorcode>001</errorcode><message>CL account has been created successfully.</message></Response>";
        } else {
            $response = $response . "<errorcode>000</errorcode><message>Problem in cl account creation. Please contact with system administrator</message></Response>";
        }
        echo $response;
        //print_r($xml);
    }

    /*  0 or null means initial save, 1 tried to signup and 2 for signup done. */

    public function actionUpdateAccount() {
        $response = "<Response>";
        if (!isset($_POST['request'])) {
            $response = $response . "<errorcode>000</errorcode><message>Request paramater is not found.</message></Response>";
            echo $response;
            return;
        }
        $request = $_POST['request'];

        $xml = simplexml_load_string($request);
        $username = $xml->username;
        $password = $xml->password;

        $errorMsg = $this->mayzusAuthenticate($username, $password);
        if ($errorMsg != "") {
            $response = $response . "<errorcode>000</errorcode><message>" . $errorMsg . "</message></Response>";
            echo $response;
            return;
        }

        $model = MayzusAccount::model()->findByPK($xml->id);
        if ($model == null) {
            $response = $response . "<errorcode>000</errorcode><message>Record( $xml->id) not found with given account to update</message></Response>";
            echo $response;
            return;
        }
        $model->username = $xml->mayzus_username;
        $model->password = $xml->mayzus_password;
        $model->verify_code1 = $xml->verify_code1;
        $model->verify_code2 = $xml->verify_code2;
        $model->date_of_birth = $xml->date_of_birth;
        $model->working = $xml->working;
        $model->referral = $xml->referral;
        $model->last_posted_date = date("Y-m-d H:i:s");
        if ($model->update()) {
            $response = $response . "<errorcode>001</errorcode><message>CL account has been updated successfully.</message></Response>";
        } else {
            $response = $response . "<errorcode>000</errorcode><message>Problem in cl account updated. Please contact with system administrator</message></Response>";
        }
        echo $response;
    }

    public function actionUpdateAllWorking() {
        $response = "<Response>";
        if (!isset($_POST['request'])) {
            $response = $response . "<errorcode>000</errorcode><message>Request paramater is not found.</message></Response>";
            echo $response;
            return;
        }
        $request = $_POST['request'];

        $xml = simplexml_load_string($request);
        $username = $xml->username;
        $password = $xml->password;
        $working = $xml->working;
        $errorMsg = $this->mayzusAuthenticate($username, $password);
        if ($errorMsg != "") {
            $response = $response . "<errorcode>000</errorcode><message>" . $errorMsg . "</message></Response>";
            echo $response;
            return;
        }

        $record = MayzusAccount::model()->findByAttributes(array('username' => $username));
        MayzusAccount::model()->updateAll(array('working' => $working), 'user_id =' . $record->id);
        $response = $response . "<errorcode>001</errorcode><message>Updated all successfully.</message></Response>";

        echo $response;
    }

    public function actionUpdateWorking() {
        $response = "<Response>";
        if (!isset($_POST['request'])) {
            $response = $response . "<errorcode>000</errorcode><message>Request paramater is not found.</message></Response>";
            echo $response;
            return;
        }
        $request = $_POST['request'];

        $xml = simplexml_load_string($request);
        $username = $xml->username;
        $password = $xml->password;
        $id = $xml->id;
        $working = $xml->working;
        $errorMsg = $this->mayzusAuthenticate($username, $password);
        if ($errorMsg != "") {
            $response = $response . "<errorcode>000</errorcode><message>" . $errorMsg . "</message></Response>";
            echo $response;
            return;
        }

        $model = MayzusAccount::model()->findByPK($id);
        $model->working = $working;
        if ($model->update()) {
            $response = $response . "<errorcode>001</errorcode><message>Updated successfully.</message></Response>";
        } else {
            $response = $response . "<errorcode>000</errorcode><message>Problem in account update. Please contact with system administrator</message></Response>";
        }
        echo $response;
    }

    public function actionUpdatePost() {
        $response = "<Response>";
        if (!isset($_POST['request'])) {
            $response = $response . "<errorcode>000</errorcode><message>Request paramater is not found.</message></Response>";
            echo $response;
            return;
        }
        $request = $_POST['request'];

        $xml = simplexml_load_string($request);
        $username = $xml->username;
        $password = $xml->password;
        $id = $xml->id;
        $posting = $xml->posting;
        $errorMsg = $this->mayzusAuthenticate($username, $password);
        if ($errorMsg != "") {
            $response = $response . "<errorcode>000</errorcode><message>" . $errorMsg . "</message></Response>";
            echo $response;
            return;
        }
        $model = MayzusAccount::model()->findByPK($id);
        if (is_null($model->have_post) || $model->have_post == "") {
            $model->have_post = 0;
        }

        $model->have_post = $model->have_post + $posting;
        if ($model->update()) {
            $response = $response . "<errorcode>001</errorcode><message>Updated successfully.</message></Response>";
        } else {
            $response = $response . "<errorcode>000</errorcode><message>Problem in account update. Please contact with system administrator</message></Response>";
        }
        echo $response;
    }

    public function actionDeleteAccount($request) {
        $response = "<Response>";
        $xml = simplexml_load_string($request);
        $username = $xml->username;
        $password = $xml->password;
        $id = $xml->id;
        $errorMsg = $this->mayzusAuthenticate($username, $password);
        if ($errorMsg != "") {
            $response = $response . "<errorcode>000</errorcode><message>" . $errorMsg . "</message></Response>";
            echo $response;
            return;
        }

        $model = MayzusAccount::model()->findByPK($id);
        if ($model->delete()) {
            $response = $response . "<errorcode>001</errorcode><message>Account has been deleted successfully.</message></Response>";
        } else {
            $response = $response . "<errorcode>000</errorcode><message>Problem in account delete. Please contact with system administrator</message></Response>";
        }
        echo $response;
    }

    public function actionGetAccounts($username, $password, $working) {
        $response = "<Response>";
        $errorMsg = $this->mayzusAuthenticate($username, $password);
        if ($errorMsg != "") {
            $response = $response . "<errorcode>000</errorcode><message>" . $errorMsg . "</message></Response>";
            echo $response;
            return;
        }

        $record = MayzusUser::model()->findByAttributes(array('username' => $username));
        $list = MayzusAccount::model()->findAll("user_id=:user and working=:working", array("user" => $record->id, "working" => $working));

        $childRes = "<accounts>";
        foreach ($list as $account) {
            $childRes = $childRes . "<account>";
            $childRes = $childRes . "<id>" . $account->id . "</id>";
            $childRes = $childRes . "<user_id>" . $account->user_id . "</user_id>";
            $childRes = $childRes . "<country_id>" . $account->country_id . "</country_id>";
            $childRes = $childRes . "<email>" . $account->email . "</email>";
            $childRes = $childRes . "<email_pass>" . $account->email_pass . "</email_pass>";
            $childRes = $childRes . "<cl_pass>" . $account->cl_pass . "</cl_pass>";
            $childRes = $childRes . "<fw_email>" . $account->fw_email . "</fw_email>";
            $childRes = $childRes . "<fw_email_pass>" . $account->fw_email_pass . "</fw_email_pass>";
            $childRes = $childRes . "<phone>" . $account->phone . "</phone>";
            $childRes = $childRes . "<state>" . $account->state . "</state>";
            $childRes = $childRes . "<city>" . $account->city . "</city>";
            $childRes = $childRes . "<link>" . $account->link . "</link>";
            $childRes = $childRes . "<proxy>" . $account->proxy . "</proxy>";
            $childRes = $childRes . "<remarks>" . $account->remarks . "</remarks>";
            $childRes = $childRes . "<username>" . $account->username . "</username>";
            $childRes = $childRes . "<password>" . $account->password . "</password>";
            $childRes = $childRes . "<working>" . $account->working . "</working>";
            $childRes = $childRes . "<can_post>" . $account->can_post . "</can_post>";
            $childRes = $childRes . "<have_post>" . $account->have_post . "</have_post>";
            $childRes = $childRes . "<referral>" . $account->referral . "</referral>";
            $childRes = $childRes . "</account>";
        }
        $childRes = $childRes . "</accounts>";

        $response = $response . "<errorcode>001</errorcode><message>Record found</message>";
        $response = $response . $childRes . "</Response>";
        echo $response;
    }

    public function actionGetPostAccounts($username, $password) {
        $response = "<Response>";
        $errorMsg = $this->mayzusAuthenticate($username, $password);
        if ($errorMsg != "") {
            $response = $response . "<errorcode>000</errorcode><message>" . $errorMsg . "</message></Response>";
            echo $response;
            return;
        }

        $record = MayzusUser::model()->findByAttributes(array('username' => $username));
        $list = MayzusAccount::model()->findAll("user_id=:user and can_post>=IFNULL(have_post,0) and working in(2,3) ORDER BY IFNULL(have_post, 0) ASC", array("user" => $record->id));

        $childRes = "<accounts>";
        foreach ($list as $account) {
            $childRes = $childRes . "<account>";
            $childRes = $childRes . "<id>" . $account->id . "</id>";
            $childRes = $childRes . "<user_id>" . $account->user_id . "</user_id>";
            $childRes = $childRes . "<country_id>" . $account->country_id . "</country_id>";
            $childRes = $childRes . "<email>" . $account->email . "</email>";
            $childRes = $childRes . "<email_pass>" . $account->email_pass . "</email_pass>";
            $childRes = $childRes . "<cl_pass>" . $account->cl_pass . "</cl_pass>";
            $childRes = $childRes . "<fw_email>" . $account->fw_email . "</fw_email>";
            $childRes = $childRes . "<fw_email_pass>" . $account->fw_email_pass . "</fw_email_pass>";
            $childRes = $childRes . "<phone>" . $account->phone . "</phone>";
            $childRes = $childRes . "<state>" . $account->state . "</state>";
            $childRes = $childRes . "<city>" . $account->city . "</city>";
            $childRes = $childRes . "<link>" . $account->link . "</link>";
            $childRes = $childRes . "<proxy>" . $account->proxy . "</proxy>";
            $childRes = $childRes . "<remarks>" . $account->remarks . "</remarks>";
            $childRes = $childRes . "<username>" . $account->username . "</username>";
            $childRes = $childRes . "<password>" . $account->password . "</password>";
            $childRes = $childRes . "<working>" . $account->working . "</working>";
            $childRes = $childRes . "<can_post>" . $account->can_post . "</can_post>";
            $childRes = $childRes . "<have_post>" . $account->have_post . "</have_post>";
            $childRes = $childRes . "<referral>" . $account->Referral . "</referral>";
            $childRes = $childRes . "</account>";
        }
        $childRes = $childRes . "</accounts>";

        $response = $response . "<errorcode>001</errorcode><message>Record found</message>";
        $response = $response . $childRes . "</Response>";
        echo $response;
    }

    public function actionDeleteAll() {
        $customForm = new CustomForm;
        $message = "";

        if (isset($_POST['CustomForm'])) {
            $id = $_POST['CustomForm']['record_id'];
            $count = MayzusAccount::model()->deleteAllByAttributes(array('user_id' => $id));
            $message = "No record found for delete for gived record id [$count]";
            if ($count > 0) {
                $message = "Deleted [$count] recordes";
            } else {
                $message = "No record found for delete for gived record id [$count]";
            }
        }
        $this->render('_custom', array(
            'model' => $customForm,
            'message' => $message,
        ));
    }

    public function actionCanPost() {
        $customForm = new CustomForm;
        $message = "";

        if (isset($_POST['CustomForm'])) {
            $id = $_POST['CustomForm']['record_id'];
            $value = $_POST['CustomForm']['value'];
            $sql = "UPDATE mayzus_account SET can_post=$value, total_post=ifnull(total_post,0)+ifnull(have_post,0),have_post=0 WHERE user_id like '$id'";
            $count = Yii::app()->db->createCommand($sql)->execute();
            //$count = MayzusAccount::model()->updateAll(array('can_post' => $value,'total_post' => 'have_post'), 'user_id =' . $id);
            if ($count > 0) {
                $message = "Updated [$count] recordes";
            } else {
                $message = "No record found for update for given record id [$id]";
            }
        }
        $this->render('_custom_canpost', array(
            'model' => $customForm,
            'message' => $message,
        ));
    }

    /**
     * Displays a particular model.
     * @param integer $id the ID of the model to be displayed
     */
    public function actionView($id) {
        $this->render('view', array(
            'model' => $this->loadModel($id),
        ));
    }

    /**
     * Creates a new model.
     * If creation is successful, the browser will be redirected to the 'view' page.
     */
    public function actionCreate() {
        $model = new MayzusAccount;

        // Uncomment the following line if AJAX validation is needed
        // $this->performAjaxValidation($model);

        if (isset($_POST['MayzusAccount'])) {
            $model->attributes = $_POST['MayzusAccount'];
            if ($model->save())
                $this->redirect(array('view', 'id' => $model->id));
        }

        $this->render('create', array(
            'model' => $model,
        ));
    }

    /**
     * Updates a particular model.
     * If update is successful, the browser will be redirected to the 'view' page.
     * @param integer $id the ID of the model to be updated
     */
    public function actionUpdate($id) {
        $model = $this->loadModel($id);

        // Uncomment the following line if AJAX validation is needed
        // $this->performAjaxValidation($model);

        if (isset($_POST['MayzusAccount'])) {
            $model->attributes = $_POST['MayzusAccount'];
            if ($model->save())
                $this->redirect(array('view', 'id' => $model->id));
        }

        $this->render('update', array(
            'model' => $model,
        ));
    }

    /**
     * Deletes a particular model.
     * If deletion is successful, the browser will be redirected to the 'admin' page.
     * @param integer $id the ID of the model to be deleted
     */
    public function actionDelete($id) {
        $this->loadModel($id)->delete();

        // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
        if (!isset($_GET['ajax']))
            $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
    }

    /**
     * Lists all models.
     */
    public function actionIndex() {
        $dataProvider = new CActiveDataProvider('MayzusAccount');
        $this->render('index', array(
            'dataProvider' => $dataProvider,
        ));
    }

    /**
     * Manages all models.
     */
    public function actionAdmin() {
        $model = new MayzusAccount('search');
        $model->unsetAttributes();  // clear any default values
        if (isset($_GET['MayzusAccount']))
            $model->attributes = $_GET['MayzusAccount'];

        $this->render('admin', array(
            'model' => $model,
        ));
    }

    /**
     * Returns the data model based on the primary key given in the GET variable.
     * If the data model is not found, an HTTP exception will be raised.
     * @param integer $id the ID of the model to be loaded
     * @return MayzusAccount the loaded model
     * @throws CHttpException
     */
    public function loadModel($id) {
        $model = MayzusAccount::model()->findByPk($id);
        if ($model === null)
            throw new CHttpException(404, 'The requested page does not exist.');
        return $model;
    }

    /**
     * Performs the AJAX validation.
     * @param MayzusAccount $model the model to be validated
     */
    protected function performAjaxValidation($model) {
        if (isset($_POST['ajax']) && $_POST['ajax'] === 'mayzus-account-form') {
            echo CActiveForm::validate($model);
            Yii::app()->end();
        }
    }

}
